Dependency Graph

The data model usually contains different dependencies among its elements. Views are based on data retrieved from tables and stored procedures, procedures themselves depend on other sources, like views and tables. User roles may define special permissions for some tables, views or schemas. It is possible build a dependency graph of the data model based on these relationships.

This particular view shows this graph in a user friendly tree form. It allows to render the model in two ways:

Direct tree: Root elements are the resources that depend on their child elements.
Inverted tree: Root elements are the parent resources and the child elements depend on them.

Please note, this view shows an effective dependency graph. It doesn't show the resources that have no relationships to other resources. Therefore, resources without dependencies or dependent elements are not displayed.

The Dependency Graph view also provides the following features:

Collapse/expand all: collapse/expand all elements in the tree.
Switch between models: switch between direct and inverted tree.
Open table or procedure definition: double clicking on a procedure, view or table opens the corresponding schema and highlights the resource.
Filter resources: show resources that contain the given search word. Matches are highlighted with bold font. The search field also has content assist features that can be activated by pressing Ctrl+Space.